package com.cnhis.cloudhealth.clinical.clidoctor.clisendadvice.dao;

import java.util.List;
import java.util.Map;

import org.springframework.cache.annotation.Cacheable;
import org.springframework.stereotype.Repository;

import com.cnhis.cloudhealth.commons.dao.BaseDao;
import java.util.HashMap;

@SuppressWarnings("rawtypes")
@Repository
public class CliSendAdviceDao extends BaseDao
{
	 
    public int getBlp02(Map map)
        throws Exception
    {
        return (int)queryForExtObject("CliNewAdvice.getBlp02", map);
    }
 
    public Integer getBlp04(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliNewAdvice.getBlp04", map);
    }
 
    public Integer getVaa10(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliNewAdvice.getVaa10", map);
    }
 
    public int getVcj04Vcj05(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliNewAdvice.getVcj04Vcj05", map);
    }
 
    public List querySendAdvice(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.querySendAdvice", map);
    }
 
    public List querySendAdvice1(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.querySendAdvice1", map);
    }
 
    public List querySendAdvice2(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.querySendAdvice2", map);
    }
 
    public List querySendAdvice3(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.querySendAdvice3", map);
    }
 
    public List querySendAdvice4(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.querySendAdvice4", map);
    }
 
    public String aDate(Map map)
        throws Exception
    {
        return (String)queryForExtObject("CliSendAdvice.aDate", map);
    }
 
    public List checkWhetherDurg(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.checkWhetherDurg", map);
    }
    public List checkWhetherVIP(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.checkWhetherVIP", map);
    }
 
    public List getFeeItemExecutionOffices(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.getFeeItemExecutionOffices", map);
    }
	 
  //  @//Cacheable(   value="Cachename1"  )  //jeig haosyo mayong   needcache
    public Map getlBCE02AndlBCE03(Map map)
        throws Exception
    {
        return (Map)queryForExtObject("CliSendAdvice.getlBCE02AndlBCE03", map);
    }
  
    public List hasAdviceSend(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.hasAdviceSend", map);
    }
    @Cacheable(value = { "Cachename1" })   //need cache
    public String getParameter(Map map)
        throws Exception
    {
        return (String)queryForExtObject("CliSendAdvice.getParameter", map);
    }
    @Cacheable(   value="Cachename1"  ) 
    public Map getlABC02AndlBCK01B(Map map)
        throws Exception
    {
        return (Map)queryForExtObject("CliSendAdvice.getlABC02AndlBCK01B", map);
    }
 
    public List tempVaj1(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tempVaj1", map);
    }
 
    public List vaj1(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.vaj1", map);
    }
 
    public List gettmpVAI(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.gettmpVAI", map);
    }
 
    public List getTmpVAJ(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.getTmpVAJ", map);
    }
 
    public List existsTmpVAJ(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.existsTmpVAJ", map);
    }
    
    public List updateTmpVAI1(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.updateTmpVAI1", map);
    }
    
    public List updateTmpVAI2(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.updateTmpVAI2", map);
    }
    
    public List updateTmpVAJ1(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.updateTmpVAJ1", map);
    }
    
    public List updateTmpVAJ2(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.updateTmpVAJ2", map);
    }
    
    public List updateBills(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.updateBills", map);
    }
   
    public Integer getreBEP06(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.getreBEP06", map);
    }
 
    public Integer sumVAJ38(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.sumVAJ38", map);
    }
  
    public Integer reVAJ38Count(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.reVAJ38Count", map);
    }
  
    public Integer reVAJ38Sum(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.reVAJ38Sum", map);
    }
     public Map cardBalance(Map map)
        throws Exception
    {
        return (Map)queryForExtObject("CliSendAdvice.cardBalance", map);
    }
     public List getTmpVafs(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.getTmpVafs", map);
    }
    
    public List getTmpVBD(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.getTmpVBD", map);
    }
  
    public Integer VBD09Count(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.VBD09Count", map);
    }
  
    public List tempVBD1Param(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tempVBD1Param", map);
    }
    
    public Integer validity(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.validity", map);
    }
 
    public String expires(Map map)
        throws Exception
    {
        return (String)queryForExtObject("CliSendAdvice.expires", map);
    }
    @Cacheable(   value="Cachename1" )  //jeig haosyoe return null so ma cache  needcache
    public Map getBCK01A(Map map)
        throws Exception
    {
        return (Map)queryForExtObject("CliSendAdvice.getBCK01A", map);
    }
 
    public Integer getTmpZJ(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.getTmpZJ", map);
    }
  
    public Integer VAJ1Count(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.VAJ1Count", map);
    }
  
    public List TmpVAJParam(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.TmpVAJParam", map);
    }
 
    public Integer cbm01Count(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.cbm01Param", map);
    }
 
    public List tmpVAIParam(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tmpVAIParam", map);
    }
   
    public List tmpVAJParam(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tmpVAJParam222", map);
    }
   
    public List tmpVAIpara(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tmpVAIpara", map);
    }
   
    public Integer getMaxID(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.getMaxID", map);
    }
 
    public List setVAIID(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.setVAIID", map);
    }
 
    public List tmpVAJParam1(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tmpVAJParam1", map);
    }
   
    public List tmpVAIParam2(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tmpVAIParam2", map);
    }
 
    public List tmpVAJParam2(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tmpVAJParam2", map);
    }
 
    public Integer MinVAI01(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.MinVAI01", map);
    }
 
    public List para258tmpVAI(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.para258tmpVAI", map);
    }
 
    public List para258tmpVAJ(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.para258tmpVAJ", map);
    }
 
    public Integer Para258_2(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.Para258_2", map);
    }
 
    public Integer Para258_2_min(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.Para258_2_min", map);
    }
    
    public List Para258_2_tmpVAJ(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.Para258_2_tmpVAJ", map);
    }
 
    public Integer getTmpVaj1MaxID(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.getTmpVaj1MaxID", map);
    }
   
    public List tempVafsParam(Map map)
        throws Exception
    {
        
        return queryForList("CliSendAdvice.tempVafsParam", map);
    }
    //@//Cacheable(   value="Cachename1"  ) 
    public List tempVAI1(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tempVAI1", map);
    }
   // @//Cacheable(   value="Cachename1"  ) 
    public List tempVaj1Param(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tempVaj1Param111", map);
    }
   // @//Cacheable(   value="Cachename1"  ) 
    public String existsBBY05(Map map)
        throws Exception
    {
        return (String)queryForExtObject("CliSendAdvice.existsBBY05", map);
    }
    
    public Integer checkStock(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.checkStock", map);
    }
    @Cacheable(   value="Cachename1"  ) 
    public String getBBY05(Map map)
        throws Exception
    {
        return (String)queryForExtObject("CliSendAdvice.getBBY05", map);
    }
   // @//Cacheable(   value="Cachename1"  ) 
    public Map getMinAndMaxVAI01(Map map)
        throws Exception
    {
        return (Map)queryForExtObject("CliSendAdvice.getMinAndMaxVAI01", map);
    }
    //@//Cacheable(   value="Cachename1"  ) 
    public Integer existsVAI1(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.existsVAI1", map);
    }
    @Cacheable(   value="Cachename1"  ) 
    public List getDEPT(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.getDEPT", map);
    }
    
    public void insertDeptlog(Map map)
        throws Exception
    {
        insert("CliSendAdvice.insertDeptlog", map);
    }
   // @//Cacheable(   value="Cachename1"  ) 
    public List tempVAIParam(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tempVAIParam", map);
    }
    //@//Cacheable(   value="Cachename1"  ) 
    public List tempVATParam(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tempVATParam", map);
    }
    //@//Cacheable(   value="Cachename1"  ) 
    public List tempVAVParam(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tempVAVParam", map);
    }
    //@//Cacheable(   value="Cachename1"  ) 
    public Integer existsTmpVafs(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.existsTmpVafs", map);
    }
    //@//Cacheable(   value="Cachename1"  ) 
    public List tempVAIParam1(Map map)
        throws Exception
    {
        return queryForList("CliSendAdvice.tempVAIParam1", map);
    }
    
    public void saveVAI(Map map)
        throws Exception
    {
        insert("CliSendAdvice.saveVAI", map);
    }
    
    public void saveVAJ(Map map)
        throws Exception
    {
        insert("CliSendAdvice.saveVAJ", map);
    }
    
    public void updateVAI(Map map)
        throws Exception
    {
        update("CliSendAdvice.updateVAI", map);
    }
    
    public void updateVAF(Map map)
        throws Exception
    {
        update("CliSendAdvice.updateVAF", map);
    }
    
    public void saveVBI(Map map)
        throws Exception
    {
        insert("CliSendAdvice.saveVBI", map);
    }
    
    public void saveVBD(Map map)
        throws Exception
    {
        
        insert("CliSendAdvice.saveVBD", map);
    }
    
    public void saveVBG(Map map)
        throws Exception
    {
        insert("CliSendAdvice.saveVBG", map);
    }
   // @//Cacheable(   value="Cachename1"  ) 
    public Integer VBGParam(Map map)
        throws Exception
    {
        return (Integer)queryForExtObject("CliSendAdvice.VBGParam", map);
    }
    
    public void saveCMB1_VAT1_VAV1(Map map)
        throws Exception
    {
        insert("CliSendAdvice.saveCMB1_VAT1_VAV1", map);
    }
    
    public void saveVBX1(Map map)
        throws Exception
    {
        insert("CliSendAdvice.saveVBX1", map);
    }
   // @//Cacheable(   value="Cachename1"  ) 
    public List getVbdInfo(HashMap map)
        throws Exception
    {
        return this.queryForList("CliSendAdvice.getVbdInfo", map);
    }

    public void saveZj(Map<String, Object> zjMap) throws Exception
    {
        this.update("CliSendAdvice.saveZj", zjMap);
    }
   // @//Cacheable(   value="Cachename1"  ) 
    public List getDEPTCl(Map map) throws Exception
    {
        return queryForList("CliSendAdvice.getDEPTCl", map);
    }

    public String getParameter1(HashMap map) throws Exception
    {
        return (String)queryForExtObject("CliSendAdvice.getParameter1", map);
    }
}
